package com.py.credit.dao;

import com.py.credit.entity.LhjcDynamicMapNum;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface LhjcDynamicMapDao {

    int selectMessNum(@Param(value = "jclb") String jclb,
                      @Param(value = "type") String type,
                      @Param(value = "glcf") String glcf,
                      @Param(value = "status") String status);

    List<LhjcDynamicMapNum> selectBmFqNum();

    List<LhjcDynamicMapNum> selectBmFeedbackNum();

    int selectGzNum(@Param(value = "jclb") String jclb,
                    @Param(value = "gzType") String gzType);

    List<LhjcDynamicMapNum> selectBmFormulateNum(@Param(value = "jclb") String jclb);

    List<LhjcDynamicMapNum> selectMonthMessNum(@Param(value = "jclb") String jclb,
                                               @Param(value = "type") String type);

    List<Map<String, String>> selectMonthBmFqId(@Param(value = "jclb") String jclb);

    List<LhjcDynamicMapNum> selectMonthBmFqNum(@Param(value = "jclb") String jclb,
                                               @Param(value = "deptId") int deptId,
                                               @Param(value = "startTime") String startTime,
                                               @Param(value = "endTime") String endTime);

    List<LhjcDynamicMapNum> selectMonthBmCyNum(@Param(value = "jclb") String jclb,
                                               @Param(value = "time") String time);

    List<LhjcDynamicMapNum> selectMessGzDistributionNum(@Param(value = "jclb") String jclb);

    List<Map<String, String>> selectAllDept();

    String selectMaxTime();

    String selectMinTime();

    int selectMessTypeNum(@Param(value = "jclb") String jclb,
                          @Param(value = "messType") String messType);

    List<LhjcDynamicMapNum> selectMessGzName(@Param(value = "jclb") String jclb);
}
